Labels:text | screenshot | purple | font | rectangle | colorfulness | violet OCR: category shrunken aggregate Product category Sales fact table dimension table time dimension table time key category_ key category _key category store dimension table store key department promo key promo dimension table gay sold doliars sold collars cost FIGURE 3 The same data warehouse showing the ag- gregates in a separate category aggregate fact table and a shrunken product category dimension table.
